<%@ page language="java" contentType="text/html; charset=utf-8"
	pageEncoding="utf-8"%>
<%@ page import="java.sql.*"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<%
       String stuId = request.getParameter("stuId");
       String inFee = request.getParameter("inFee");
       String outFee = request.getParameter("outFee");
       String date = request.getParameter("date");
       String useWay = new String(request.getParameter("useWay").getBytes("ISO8859-1"));
       try{
       	   Class.forName("com.mysql.jdbc.Driver").newInstance();
       	   Connection con = java.sql.DriverManager.getConnection("jdbc:mysql://localhost:3306/classfee", "root", "1234");
       	   Statement stmt = con.createStatement();
    	       stmt.executeUpdate("insert into tb_classfee(stuId,inFee,outFee,date,useWay) values('"+stuId+"','" +inFee+"','"+outFee+"','"+date+"','"+useWay+"')");
    	       out.println("<script>alert('添加成功!');window.location='classfeeadd1.jsp'</script>");
    	       stmt.close();
    	       con.close();
         }
      catch(Exception ex)
      { 
    	   out.println("<script>alert('添加失败!');window.location='classfeeadd.html')</script>");
    	   out.println(ex.getMessage());
      }
	       
%>
